<?php
	include('Connection.php');
	$currLoc = $_POST['change_car_loc'];
	$model = $_POST['choose_car'];
	
	$query = "SELECT VehicleSno FROM car WHERE CarLocation='$currLoc' AND CarModel='$model';";
	mysql_query($query);
	
	$newLoc = $_POST['curr_loc'];
	$sno = mysql_fetch_object($result);
	$type = $_POST['new_car_type'];
	$color = $_POST['new_car_color'];
	$seating = $_POST['new_seating_cap'];
	$transmission = $_POST['new_trans_type']; 
	
	$update = "UPDATE car 
			  SET CarLocation='$carLoc', Type='$type', Color='$color,' Seating_Capactiy='$seating', Transmmission_Type='$transmisstion'
			  WHERE VehicleSno='$sno->VehicleSno';";
			  
	mysql_query($update);
?>